Business Intelligence Easy: Excel Dashboard for Top Managers by Voldemar Sokolof

Author:Voldemar Sokolof
Language: eng
Format: azw3
Published: 2015-03-04T08:00:00+00:00

If you get back to the mind map of our dashboard you may actually see that this table is representing the first category in both: A and B-lists – Revenue: Total. So the total scope of Source Table is A-list categories multiplied by B-list categories – 38 unique combinations in total for our imaginary case.

Ok, you may have gotten the idea right now with this Source Data Table. Copy and paste first table until you have covered the scope of the Source Table. Though 38 tables is quite long list, as long as you made the first one right, the other 37 are just copy-paste procedure. Yet, pay attention that you need to name each of them according to the mind map. So first three tables are like this: under “Revenue” we have “Revenue: Total”, “Revenue: Fruits”, “Revenue: Vegetables” and so on.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.